package com.bdqn.oa.dao;

import com.bdqn.oa.entity.Leave;
import com.bdqn.oa.entity.Reimbursement;

import java.sql.SQLException;
import java.util.Date;
import java.util.List;

/**
 * @author Chenrz
 * @date 2022/7/20 16:59
 */
public interface ReimbursementDao {
    /**
     * 新增报销
     * @param rei
     * @return
     * @throws SQLException
     */
    public int saveRei(Reimbursement rei) throws SQLException;

    /**
     * 通过id删除报销
     * @param employeeId
     * @return
     * @throws SQLException
     */
    public int deleteRei(Integer employeeId) throws SQLException;

    /**
     * 修改报销
     * @param rei
     * @return
     * @throws SQLException
     */
    public int updateRei(Reimbursement rei) throws SQLException;

    /**
     * 审批报销
     * @param rei
     * @return
     * @throws SQLException
     */
    public int updateReiByStatus(Reimbursement rei) throws SQLException;

    /**
     * 通过员工id查询报销
     * @param employeeId
     * @return
     * @throws SQLException
     */
    public List<Reimbursement> getListReiById(Integer employeeId) throws SQLException;

    /**
     * 查询某一天的所有报销
     * @param datetime
     * @return
     * @throws SQLException
     */
    public List<Reimbursement> getListReiByDay(Date datetime) throws SQLException;

    /**
     * 查询所有报销
     * @return
     * @throws SQLException
     */
    public List<Reimbursement> getAllListRei() throws SQLException;
}
